Select * from [Options] where convert(varchar, [Options].[DBId]) + ‘-‘ + [Options].[Variable] + ‘-‘ + [Options].[OrgTable] + ‘-‘ + [Options].[OrgTable] + ‘-‘ + convert(varchar, [Options].[FieldId]) in (Select convert(varchar, [Options].[DBId]) + ‘-‘ + [Options].[Variable] + ‘-‘ + [Options].[OrgTable] + ‘-‘ + [Options].[OrgTable] + ‘-‘ + convert(varchar, [Options].[FieldId]) from ([Options] Left Join [GLAccount] ON [Options].[ReferenceId] = [GLAccount].[Id] and … Continue reading Query: Check accounts in options